home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 11 / developer source - volume 11.iso / dbmsa / jan97 / kimbf103.gif < prev    next >
Graphics Interchange Format  |  1998-02-10  |  45.4 KB  |  341x310  |  4-bit (16 colors)
   ocr: Time key Time Dimension R10 Customer Dimension Customer key Product key 0E0 Product Dimensions Join Promotion Dimension Promotion Kes soin Salespersonkey Salesperson: cins Dimension Status mension Dauser Quantity: sold THIS Extendedlist price MINUS Total allowances MINUS Total discounts EQUALS Extended net: price l REVENUE SHOULD WE STORE) T YES! Figure 3. A typical customer billing fact table in which the extended net price can be derived from the other quantities, but nevertheless we want to store it in the table.